package com.itheima.health.dao;

import com.itheima.health.pojo.Member;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * @author deng
 * @package com.itheima.health.dao
 * @date Created in 2024/7/15 08:41
 */
public interface ReportDao {

    @Select("select t_setmeal.name, count(*) value from t_order inner join " +
            "t_setmeal on t_order.setmeal_id = t_setmeal.id group by t_setmeal.name;")
    List<Map> find();
}
